SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchRecruitmentBytopicPublic]
	(
	@param_topic NVarChar(100)
	)
AS
	/* SET NOCOUNT ON */
	Select * from dbo.JOL_Recruitment where topic like '%'+@param_topic+'%' AND state='True' 
	ORDER BY start_time Desc, verify_time DESC
	RETURN
GO
